// ******************************************************************
// * Copyright(c)  Steven Lu
// * Description   : Schema_HR_EMPLOYEE
// * CreateDate    : 2014-11-18 14:17:04
// * Creater       : CodeSmith
// * LastChangeDate: 2014-11-18 14:17:04
// * LastChanger   : 2014-11-18 14:17:04
// * Version Info  : 1.0 For ESOL
// ******************************************************************

using System;
using System.Collections.Generic;
using System.Text;
using Suzsoft.Smart.EntityCore;

namespace ESOL.Common.Schema
{
    [Serializable]
    public partial class HrEmployeeTable : TableInfo
    {
        public const string C_TableName = "HR_EMPLOYEE";

        public const string C_PERSON_ID = "PERSON_ID";
        public const string C_ID_NO = "ID_NO";
        public const string C_JOIN_DATE = "JOIN_DATE";
        public const string C_LEAVE_DATE = "LEAVE_DATE";
        public const string C_BASIC_SALARY = "BASIC_SALARY";
        public const string C_POLITICAL_LANDSCAPE = "POLITICAL_LANDSCAPE";
        public const string C_JOIN_PARTY_DATE = "JOIN_PARTY_DATE";
        public const string C_EDUCATION = "EDUCATION";
        public const string C_MAJOR = "MAJOR";
        public const string C_MINOR = "MINOR";
        public const string C_OFFICE_PHONE = "OFFICE_PHONE";
        public const string C_CONTRACT_END_DATE = "CONTRACT_END_DATE";
        public const string C_CONTRACT_CODE = "CONTRACT_CODE";
        public const string C_IS_MARRIED = "IS_MARRIED";
        public const string C_SOCIAL_FUND_AMOUNT = "SOCIAL_FUND_AMOUNT";
        public const string C_NATIVE_ADDRESS = "NATIVE_ADDRESS";
        public const string C_TITLE = "TITLE";
        public const string C_IS_SOCIAL_SECURITY = "IS_SOCIAL_SECURITY";
        public const string C_SOCIAL_SECURITY_NO = "SOCIAL_SECURITY_NO";
        public const string C_EMPLOYEE_NAME = "EMPLOYEE_NAME";
        public const string C_EMPLOYEE_NO = "EMPLOYEE_NO";
        public const string C_DEPARTMENT_NO = "DEPARTMENT_NO";
        public const string C_POSITION_ID = "POSITION_ID";
        public const string C_SUPERVISOR = "SUPERVISOR";
        public const string C_GENDER = "GENDER";
        public const string C_BIRTHDAY = "BIRTHDAY";
        public const string C_COUNTRY = "COUNTRY";
        public const string C_PROVINCE = "PROVINCE";
        public const string C_CITY = "CITY";
        public const string C_ADDRESS = "ADDRESS";
        public const string C_EMAIL = "EMAIL";
        public const string C_MOBILE = "MOBILE";
        public const string C_TELEPHONE = "TELEPHONE";
        public const string C_STATUS = "STATUS";
        public const string C_ADVANCE_AMOUNT = "ADVANCE_AMOUNT";
        public const string C_PERSON_IMAGE = "PERSON_IMAGE";

        public HrEmployeeTable()
        {
            _tableName = "HR_EMPLOYEE";
        }

        protected static HrEmployeeTable _current;
        public static HrEmployeeTable Current
        {
            get
            {
                if (_current == null)
                {
                    Initial();
                }
                return _current;
            }
        }

        private static void Initial()
        {
            _current = new HrEmployeeTable();

            _current.Add(C_PERSON_ID, new ColumnInfo(C_PERSON_ID, "PersonId", true, typeof(string)));
            _current.Add(C_ID_NO, new ColumnInfo(C_ID_NO, "IdNo", false, typeof(string)));
            _current.Add(C_JOIN_DATE, new ColumnInfo(C_JOIN_DATE, "JoinDate", false, typeof(DateTime)));
            _current.Add(C_LEAVE_DATE, new ColumnInfo(C_LEAVE_DATE, "LeaveDate", false, typeof(DateTime)));
            _current.Add(C_BASIC_SALARY, new ColumnInfo(C_BASIC_SALARY, "BasicSalary", false, typeof(decimal)));
            _current.Add(C_POLITICAL_LANDSCAPE, new ColumnInfo(C_POLITICAL_LANDSCAPE, "PoliticalLandscape", false, typeof(string)));
            _current.Add(C_JOIN_PARTY_DATE, new ColumnInfo(C_JOIN_PARTY_DATE, "JoinPartyDate", false, typeof(DateTime)));
            _current.Add(C_EDUCATION, new ColumnInfo(C_EDUCATION, "Education", false, typeof(string)));
            _current.Add(C_MAJOR, new ColumnInfo(C_MAJOR, "Major", false, typeof(string)));
            _current.Add(C_MINOR, new ColumnInfo(C_MINOR, "Minor", false, typeof(string)));
            _current.Add(C_OFFICE_PHONE, new ColumnInfo(C_OFFICE_PHONE, "OfficePhone", false, typeof(string)));
            _current.Add(C_CONTRACT_END_DATE, new ColumnInfo(C_CONTRACT_END_DATE, "ContractEndDate", false, typeof(DateTime)));
            _current.Add(C_CONTRACT_CODE, new ColumnInfo(C_CONTRACT_CODE, "ContractCode", false, typeof(string)));
            _current.Add(C_IS_MARRIED, new ColumnInfo(C_IS_MARRIED, "IsMarried", false, typeof(int)));
            _current.Add(C_SOCIAL_FUND_AMOUNT, new ColumnInfo(C_SOCIAL_FUND_AMOUNT, "SocialFundAmount", false, typeof(decimal)));
            _current.Add(C_NATIVE_ADDRESS, new ColumnInfo(C_NATIVE_ADDRESS, "NativeAddress", false, typeof(string)));
            _current.Add(C_TITLE, new ColumnInfo(C_TITLE, "Title", false, typeof(string)));
            _current.Add(C_IS_SOCIAL_SECURITY, new ColumnInfo(C_IS_SOCIAL_SECURITY, "IsSocialSecurity", false, typeof(int)));
            _current.Add(C_SOCIAL_SECURITY_NO, new ColumnInfo(C_SOCIAL_SECURITY_NO, "SocialSecurityNo", false, typeof(string)));
            _current.Add(C_EMPLOYEE_NAME, new ColumnInfo(C_EMPLOYEE_NAME, "EmployeeName", false, typeof(string)));
            _current.Add(C_EMPLOYEE_NO, new ColumnInfo(C_EMPLOYEE_NO, "EmployeeNo", false, typeof(string)));
            _current.Add(C_DEPARTMENT_NO, new ColumnInfo(C_DEPARTMENT_NO, "DepartmentNo", false, typeof(string)));
            _current.Add(C_POSITION_ID, new ColumnInfo(C_POSITION_ID, "PositionId", false, typeof(string)));
            _current.Add(C_SUPERVISOR, new ColumnInfo(C_SUPERVISOR, "Supervisor", false, typeof(string)));
            _current.Add(C_GENDER, new ColumnInfo(C_GENDER, "Gender", false, typeof(string)));
            _current.Add(C_BIRTHDAY, new ColumnInfo(C_BIRTHDAY, "Birthday", false, typeof(string)));
            _current.Add(C_COUNTRY, new ColumnInfo(C_COUNTRY, "Country", false, typeof(string)));
            _current.Add(C_PROVINCE, new ColumnInfo(C_PROVINCE, "Province", false, typeof(string)));
            _current.Add(C_CITY, new ColumnInfo(C_CITY, "City", false, typeof(string)));
            _current.Add(C_ADDRESS, new ColumnInfo(C_ADDRESS, "Address", false, typeof(string)));
            _current.Add(C_EMAIL, new ColumnInfo(C_EMAIL, "Email", false, typeof(string)));
            _current.Add(C_MOBILE, new ColumnInfo(C_MOBILE, "Mobile", false, typeof(string)));
            _current.Add(C_TELEPHONE, new ColumnInfo(C_TELEPHONE, "Telephone", false, typeof(string)));
            _current.Add(C_STATUS, new ColumnInfo(C_STATUS, "Status", false, typeof(string)));
            _current.Add(C_ADVANCE_AMOUNT, new ColumnInfo(C_ADVANCE_AMOUNT, "AdvanceAmount", false, typeof(decimal)));
            _current.Add(C_PERSON_IMAGE, new ColumnInfo(C_PERSON_IMAGE, "PersonImage", false, typeof(byte[])));

        }

        public ColumnInfo PERSON_ID
        {
            get { return this[C_PERSON_ID]; }
        }

        public ColumnInfo ID_NO
        {
            get { return this[C_ID_NO]; }
        }

        public ColumnInfo JOIN_DATE
        {
            get { return this[C_JOIN_DATE]; }
        }

        public ColumnInfo LEAVE_DATE
        {
            get { return this[C_LEAVE_DATE]; }
        }

        public ColumnInfo BASIC_SALARY
        {
            get { return this[C_BASIC_SALARY]; }
        }

        public ColumnInfo POLITICAL_LANDSCAPE
        {
            get { return this[C_POLITICAL_LANDSCAPE]; }
        }

        public ColumnInfo JOIN_PARTY_DATE
        {
            get { return this[C_JOIN_PARTY_DATE]; }
        }

        public ColumnInfo EDUCATION
        {
            get { return this[C_EDUCATION]; }
        }

        public ColumnInfo MAJOR
        {
            get { return this[C_MAJOR]; }
        }

        public ColumnInfo MINOR
        {
            get { return this[C_MINOR]; }
        }

        public ColumnInfo OFFICE_PHONE
        {
            get { return this[C_OFFICE_PHONE]; }
        }

        public ColumnInfo CONTRACT_END_DATE
        {
            get { return this[C_CONTRACT_END_DATE]; }
        }

        public ColumnInfo CONTRACT_CODE
        {
            get { return this[C_CONTRACT_CODE]; }
        }

        public ColumnInfo IS_MARRIED
        {
            get { return this[C_IS_MARRIED]; }
        }

        public ColumnInfo SOCIAL_FUND_AMOUNT
        {
            get { return this[C_SOCIAL_FUND_AMOUNT]; }
        }

        public ColumnInfo NATIVE_ADDRESS
        {
            get { return this[C_NATIVE_ADDRESS]; }
        }

        public ColumnInfo TITLE
        {
            get { return this[C_TITLE]; }
        }

        public ColumnInfo IS_SOCIAL_SECURITY
        {
            get { return this[C_IS_SOCIAL_SECURITY]; }
        }

        public ColumnInfo SOCIAL_SECURITY_NO
        {
            get { return this[C_SOCIAL_SECURITY_NO]; }
        }

        public ColumnInfo EMPLOYEE_NAME
        {
            get { return this[C_EMPLOYEE_NAME]; }
        }

        public ColumnInfo EMPLOYEE_NO
        {
            get { return this[C_EMPLOYEE_NO]; }
        }

        public ColumnInfo DEPARTMENT_NO
        {
            get { return this[C_DEPARTMENT_NO]; }
        }

        public ColumnInfo POSITION_ID
        {
            get { return this[C_POSITION_ID]; }
        }

        public ColumnInfo SUPERVISOR
        {
            get { return this[C_SUPERVISOR]; }
        }

        public ColumnInfo GENDER
        {
            get { return this[C_GENDER]; }
        }

        public ColumnInfo BIRTHDAY
        {
            get { return this[C_BIRTHDAY]; }
        }

        public ColumnInfo COUNTRY
        {
            get { return this[C_COUNTRY]; }
        }

        public ColumnInfo PROVINCE
        {
            get { return this[C_PROVINCE]; }
        }

        public ColumnInfo CITY
        {
            get { return this[C_CITY]; }
        }

        public ColumnInfo ADDRESS
        {
            get { return this[C_ADDRESS]; }
        }

        public ColumnInfo EMAIL
        {
            get { return this[C_EMAIL]; }
        }

        public ColumnInfo MOBILE
        {
            get { return this[C_MOBILE]; }
        }

        public ColumnInfo TELEPHONE
        {
            get { return this[C_TELEPHONE]; }
        }

        public ColumnInfo STATUS
        {
            get { return this[C_STATUS]; }
        }

        public ColumnInfo ADVANCE_AMOUNT
        {
            get { return this[C_ADVANCE_AMOUNT]; }
        }

        public ColumnInfo PERSON_IMAGE
        {
            get { return this[C_PERSON_IMAGE]; }
        }



    }
}

